

*****************************
*** ANALYSIS COUNTY LEVEL ***
*****************************


use county_level.dta

xtset fips year


* TABLE A2 (lower panel): Descriptive Statistics - Fracking and Environmental Enforcement
sum fracked frackingwell employment energy_emp natres_emp trade_emp const_emp nonemergy_emp manuf_emp pro_emp leis_emp educ_emp


* TABLE A3: Fracking and Energy-Related Employment - County Level
xtreg lnemployment treatment fracked did i.year, fe robust 
xtreg lnenergy_emp treatment fracked did i.year, fe robust 
xtreg lnnatres_emp treatment fracked did i.year, fe robust 
xtreg lntrade_emp treatment fracked did i.year, fe robust 
xtreg lnconst_emp treatment fracked did i.year, fe robust 

sum lnemployment lnenergy_emp lnnatres_emp lntrade_emp lnconst_emp


* TABLE A4: Fracking and Non-Energy-Related Employment - County Level
xtreg lnnonemergy_emp treatment fracked did i.year, fe robust 
xtreg lnmanuf_emp treatment fracked did i.year, fe robust 
xtreg lnpro_emp treatment fracked did i.year, fe robust 
xtreg lnleis_emp treatment fracked did i.year, fe robust 
xtreg lneduc_emp treatment fracked did i.year, fe robust 

sum lnnonemergy_emp lnmanuf_emp lnpro_emp lnleis_emp lneduc_emp




















